Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);
3 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
4
5 ?>
6 <?php
7 SESSION_START();
8 ?>
9
10 <!DOCTYPE html>
11 <html>
12
13 <head>
14 <meta charset="utf-8">
15 <meta name="viewport" content="width=device-width, initial-scale=1.0">
16 <title>school management system</title>
17 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
18 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
19 <link href="assets/css/loader.css" rel="stylesheet" />
20 <script src="assets/js/canvasjs.min.js"></script>
21 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
22 <script src="assets/js/jquery-3.2.1.js"></script>
23 <!--codes to run the script for constituencies and counties-->
24 <script type='text/javascript'>
25 function OnSelectionChange(county_id) {
26 var selectedOption = county_id.options[county_id.selectedIndex];
27 document.getElementById('selectedcounty').value = selectedOption.value;
28
29 }
30 </script>
31
32
33
34
35 <!--codes to run the script for constituencies and counties-->
36 <style type="text/css">
37 h4{
38 color:red;
39 }
40 </style>
41 <!--styling up the heading of form-->
42
43 </head>
44
45 <body >
46 <!--end of heading section-->
47 <ul class="nav navbar-right top-nav">
48 <div class="dropdown">
49 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
50 <?php
51 //Check to see if the user is logged in.if not redirect user to the loging page.
52
53 if(isset($_SESSION['fname']))
54 {
55 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
56 }else{
57 echo "<script type='text/javascript'>
58 alert( 'You must Log in to use the system');
59 </script>";
60 echo "<script>
61 window.location = 'index.php'
62 </script>";
63 }
64 ?>
65 <span class="caret"></span></button>
66 <ul class="dropdown-menu">
67 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
68 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
69 <li class="divider"></li>
70 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
71 </ul>
72 </div>
73 </ul>
74 <!--************************************************-->
75 <div style="
76 font-family:Nyala, Arial;
77 text-align: left;
78 background-color: #526F35;
79 padding: 20px;
80 color:white;
81 width: 100%;
82 height: 150px;">
83 <!--This codes to load the image loader-->
84 <div id="loading">
85 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
86 </div>
87 <!--this is the heading section-->
88 <h2>
89 <?php
90 include('connect.php');
91 $sql="SELECT * FROM companyinfo";
92 $result=mysqli_query($db,$sql) or die("error getting data");
93 $num_rows=mysqli_num_rows($result);
94 while($row=mysqli_fetch_array($result))
95 {
96 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
97 $cname = $row['cname'];
98 $cemail = $row['cemail'];
99 $ccontact = $row['ccontact'];
100 $clocation = $row['clocation'];
101 }?>
102 <?php
103 echo $cname;
104 ?>
105
106 <div style="float:right; font-size:20px;text-align:right;">
107
108 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
109 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
110 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
111
112 </div>
113 </h2>
114 </div>
115 <!--end of heading section-->
116
117
118 <div>
119 <ul class="nav nav-tabs">
120 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
121 <li><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
122 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
123 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
124 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
125 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
126 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
127 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
128 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
129 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
130
131 </ul>
132 <div class="tab-content">
133 <div class="tab-pane active" role="tabpanel" id="tab-1">
134
135 <p>
136 <div class="table-responsive" >
137 <!--**************************************************************************************************************************-->
138 <div class="container" style="width:100%">
139
140 <ul class="nav nav-tabs">
141 <li class="active"><a href="register_form.php">New user <img src="assets/img/new.png"> </a></li>
142 <li><a href="manage_account.php">View users<img src="assets/img/view2.png"></a></li>
143
144 </ul>
145 <br>
146
147 </div>
148 <!--**************ths is the success msg on saving the cord-->
149
150 <!--*************************************************************************************************************************-->
151
152 <div class="row">
153 <div class="col-sm-3">
154 </div>
155 <div class="col-sm-6" >
156 <form method="POST" action="register_form.php">
157 <div class="form-group">
158 <input type="text" name="fname" id="fname" class="form-control" placeholder="First Name" required autofocus/>
159 </div>
160 <div class="form-group">
161 <input type="text" name="lname" id="lname" class="form-control" placeholder="Last Name" required autofocus/>
162 </div>
163 <div class="form-group">
164 <input type="text" name="username" id="username" class="form-control" placeholder="Desired Username" required autofocus/>
165 </div>
166 <div class="form-group">
167 <input type="email" name="email" id="email" class="form-control" placeholder="Email Address" required/>
168 </div>
169 <div class="form-group">
170 <select name="role" id="role" class="form-control" placeholder="roles" required>
171 <option>adm</option>
172 <option>tutor</option>
173 <option>others</option>
174 </select>
175 </div>
176 <div class="form-group">
177 <input type="password" name="password" id="password" class="form-control" placeholder="Enter Password" required/>
178 </div>
179 <br>
180 <div class="row-md-5 col-md-offset-6 column">
181 <button type="submit" id="submit" name="register" class="btn btn-primary">Save</button>
182 <a href="homepage.php" class="btn btn-primary">Back</a>
183 </div>
184 </form>
185 </div>
186
187 </div>
188 </div>
189
190
191 </div>
192 <br>
193 <br>
194 <br>
195 <br>
196 <br>
197 <div class="row-fluid">
198 <div class="col-md-3 col-md-offset-1">
199
200
201
202 </div></div>
203
204
205
206 <div class="row-fluid">
207 <div class="col-md-5 col-md-offset-2">
208 <h4><span id=tick2>
209 </span>
210
211 </div>
212 </div>
213 </div>
214 </div>
215 </div>
216
217 <?php
218 if (isset($_POST['register'])){
219
220 $fname=$_POST['fname'];
221 $lname=$_POST['lname'];
222 $username=$_POST['username'];
223 $role=$_POST['role'];
224 $email=$_POST['email'];
225 $password=$_POST['password'];
226
227 $query = mysqli_query("select * from admin where username = '$username' and password = '$password' and fname = '$fname' and lname = '$lname' and email = '$email' and role = '$role' ")or die(mysqli_error());
228 $count = mysqli_num_rows($query);
229
230 if ($count > 0){ ?>
231 <script>
232 alert('Data Already Exist');
233 </script>
234 <?php
235 }else{
236 mysqli_query("insert into admin (fname,lname,username,password,email,role) values('$fname','$lname','$username','$password','$email','$role')")or die(mysqli_error());
237
238 }
239
240 ?>
241 <script>
242 alert('Succsessfully Save');
243 window.location = "index.php";
244 </script>
245 <?php
246 }?>
247
248 </div>
249
250
251 </center>
252 </div>
253 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
254 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
255 </div>
256 <script src="assets/js/jquery.min.js"></script>
257 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
258 <script src="assets/js/affix.js"></script>
259 <script src="assets/js/alert.js"></script>
260 <script src="assets/js/alert1.js"></script>
261 <script src="assets/js/bootstrap.js"></script>
262 <script src="assets/js/bootstrap.min.js"></script>
263 <script src="assets/js/bootstrap-datepicker.js"></script>
264 <script src="assets/js/bootstrap-wysihtml5.js"></script>
265 <script src="assets/js/button.js"></script>
266 <script src="assets/js/carousel.js"></script>
267 <script src="assets/js/chosen.jquery.min.js"></script>
268 <script src="assets/js/ckeditor.js"></script>
269 <script src="assets/js/collapse.js"></script>
270 <script src="assets/js/color.js"></script>
271 <script src="assets/js/dropdown.js"></script>
272 <script src="assets/js/DT_bootstrap.js"></script>
273 <script src="assets/js/dynamic.js"></script>
274 <script src="assets/js/ie-emulation-modes-warning.js"></script>
275 <script src="assets/js/jquery.dataTables.js"></script>
276 <script src="assets/js/jquery.dataTables.min.js"></script>
277 <script src="assets/js/jquery.dialog.js"></script>
278 <script src="assets/js/jquery.hoverdir.js"></script>
279 <script src="assets/js/jquery.jgrowl.js"></script>
280 <script src="assets/js/jquery.knob.js"></script>
281 <script src="assets/js/jquery.uniform.min.js"></script>
282 <script src="assets/js/jquery-1.8.3.min.js"></script>
283 <script src="assets/js/jquery-1.9.1.js"></script>
284 <script src="assets/js/jquery-1.9.1.min.js"></script>
285 <script src="assets/js/jquery-1.10.2.js"></script>
286 <script src="assets/js/jquery-1.11.0.js"></script>
287 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
288 <script src="assets/js/jquery-ui-1.10.3.js"></script>
289 <script src="assets/js/modal.js"></script>
290 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
291 <script src="assets/js/myjquery.js"></script>
292 <script src="assets/js/myjquery1.js"></script>
293 <script src="assets/js/npm.js"></script>
294 <script src="assets/js/popover.js"></script>
295 <script src="assets/js/profile.js"></script>
296 <script src="assets/js/raphael-min.js"></script>
297 <script src="assets/js/sb-admin-2.js"></script>
298 <script src="assets/js/scripts.js"></script>
299 <script src="assets/js/scrollspy.js"></script>
300 <script src="assets/js/tab.js"></script>
301 <script src="assets/js/tooltip.js"></script>
302 <script src="assets/js/transition.js"></script>
303 <script src="assets/js/wysihtml5-0.3.0.js"></script>
304 <!--when everything is fine the loades stops loadeing-->
305 <script language="javascript" type="text/javascript">
306 $(window).load(function()
307 {
308 $('#loading').hide();
309 });
310 </script>
311
312 </body>
313 </html>